{
  "statement":"with ss as\n (select s_store_sk,\n         sum(ss_ext_sales_price) as sales,\n         sum(ss_net_profit) as profit\n from store_sales,\n      date_dim,\n      store\n where ss_sold_date_sk \u003d d_date_sk\n       and d_date between cast(\u00272000-08-23\u0027 as date) \n                  and date_add(cast(\u00272000-08-23\u0027 as date),  30)\n       and ss_store_sk \u003d s_store_sk\n group by s_store_sk)\n ,\n sr as\n (select s_store_sk,\n         sum(sr_return_amt) as returns,\n         sum(sr_net_loss) as profit_loss\n from store_returns,\n      date_dim,\n      store\n where sr_returned_date_sk \u003d d_date_sk\n       and d_date between cast(\u00272000-08-23\u0027 as date)\n                  and date_add(cast(\u00272000-08-23\u0027 as date),  30)\n       and sr_store_sk \u003d s_store_sk\n group by s_store_sk), \n cs as\n (select cs_call_center_sk,\n        sum(cs_ext_sales_price) as sales,\n        sum(cs_net_profit) as profit\n from catalog_sales,\n      date_dim\n where cs_sold_date_sk \u003d d_date_sk\n       and d_date between cast(\u00272000-08-23\u0027 as date)\n                  and date_add(cast(\u00272000-08-23\u0027 as date),  30)\n group by cs_call_center_sk \n ), \n cr as\n (select cr_call_center_sk,\n         sum(cr_return_amount) as returns,\n         sum(cr_net_loss) as profit_loss\n from catalog_returns,\n      date_dim\n where cr_returned_date_sk \u003d d_date_sk\n       and d_date between cast(\u00272000-08-23\u0027 as date)\n                  and date_add(cast(\u00272000-08-23\u0027 as date),  30)\n group by cr_call_center_sk\n ), \n ws as\n ( select wp_web_page_sk,\n        sum(ws_ext_sales_price) as sales,\n        sum(ws_net_profit) as profit\n from web_sales,\n      date_dim,\n      web_page\n where ws_sold_date_sk \u003d d_date_sk\n       and d_date between cast(\u00272000-08-23\u0027 as date)\n                  and date_add(cast(\u00272000-08-23\u0027 as date),  30)\n       and ws_web_page_sk \u003d wp_web_page_sk\n group by wp_web_page_sk), \n wr as\n (select wp_web_page_sk,\n        sum(wr_return_amt) as returns,\n        sum(wr_net_loss) as profit_loss\n from web_returns,\n      date_dim,\n      web_page\n where wr_returned_date_sk \u003d d_date_sk\n       and d_date between cast(\u00272000-08-23\u0027 as date)\n                  and date_add(cast(\u00272000-08-23\u0027 as date),  30)\n       and wr_web_page_sk \u003d wp_web_page_sk\n group by wp_web_page_sk)\n  select  channel\n        , id\n        , sum(sales) as sales\n        , sum(returns) as returns\n        , sum(profit) as profit\n from \n (select \u0027store channel\u0027 as channel\n        , ss.s_store_sk as id\n        , sales\n        , coalesce(returns, 0) as returns\n        , (profit - coalesce(profit_loss,0)) as profit\n from   ss left join sr\n        on  ss.s_store_sk \u003d sr.s_store_sk\n union all\n select \u0027catalog channel\u0027 as channel\n        , cs_call_center_sk as id\n        , sales\n        , returns\n        , (profit - profit_loss) as profit\n from  cs\n       , cr\n union all\n select \u0027web channel\u0027 as channel\n        , ws.wp_web_page_sk as id\n        , sales\n        , coalesce(returns, 0) returns\n        , (profit - coalesce(profit_loss,0)) as profit\n from   ws left join wr\n        on  ws.wp_web_page_sk \u003d wr.wp_web_page_sk\n ) x\n group by rollup (channel, id)\n order by channel\n         ,id\n limit 100;\n",
  "table_meta":{
    "tpcds.catalog_sales":"CREATE TABLE `catalog_sales` (\n  `cs_item_sk` int(11) NOT NULL COMMENT \"\",\n  `cs_order_number` int(11) NOT NULL COMMENT \"\",\n  `cs_sold_date_sk` int(11) NULL COMMENT \"\",\n  `cs_sold_time_sk` int(11) NULL COMMENT \"\",\n  `cs_ship_date_sk` int(11) NULL COMMENT \"\",\n  `cs_bill_customer_sk` int(11) NULL COMMENT \"\",\n  `cs_bill_cdemo_sk` int(11) NULL COMMENT \"\",\n  `cs_bill_hdemo_sk` int(11) NULL COMMENT \"\",\n  `cs_bill_addr_sk` int(11) NULL COMMENT \"\",\n  `cs_ship_customer_sk` int(11) NULL COMMENT \"\",\n  `cs_ship_cdemo_sk` int(11) NULL COMMENT \"\",\n  `cs_ship_hdemo_sk` int(11) NULL COMMENT \"\",\n  `cs_ship_addr_sk` int(11) NULL COMMENT \"\",\n  `cs_call_center_sk` int(11) NULL COMMENT \"\",\n  `cs_catalog_page_sk` int(11) NULL COMMENT \"\",\n  `cs_ship_mode_sk` int(11) NULL COMMENT \"\",\n  `cs_warehouse_sk` int(11) NULL COMMENT \"\",\n  `cs_promo_sk` int(11) NULL COMMENT \"\",\n  `cs_quantity` int(11) NULL COMMENT \"\",\n  `cs_wholesale_cost` decimal(7, 2) NULL COMMENT \"\",\n  `cs_list_price` decimal(7, 2) NULL COMMENT \"\",\n  `cs_sales_price` decimal(7, 2) NULL COMMENT \"\",\n  `cs_ext_discount_amt` decimal(7, 2) NULL COMMENT \"\",\n  `cs_ext_sales_price` decimal(7, 2) NULL COMMENT \"\",\n  `cs_ext_wholesale_cost` decimal(7, 2) NULL COMMENT \"\",\n  `cs_ext_list_price` decimal(7, 2) NULL COMMENT \"\",\n  `cs_ext_tax` decimal(7, 2) NULL COMMENT \"\",\n  `cs_coupon_amt` decimal(7, 2) NULL COMMENT \"\",\n  `cs_ext_ship_cost` decimal(7, 2) NULL COMMENT \"\",\n  `cs_net_paid` decimal(7, 2) NULL COMMENT \"\",\n  `cs_net_paid_inc_tax` decimal(7, 2) NULL COMMENT \"\",\n  `cs_net_paid_inc_ship` decimal(7, 2) NULL COMMENT \"\",\n  `cs_net_paid_inc_ship_tax` decimal(7, 2) NULL COMMENT \"\",\n  `cs_net_profit` decimal(7, 2) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`cs_item_sk`, `cs_order_number`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`cs_item_sk`, `cs_order_number`) BUCKETS 192 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\"\n);",
    "tpcds.web_page":"CREATE TABLE `web_page` (\n  `wp_web_page_sk` int(11) NOT NULL COMMENT \"\",\n  `wp_web_page_id` char(16) NOT NULL COMMENT \"\",\n  `wp_rec_start_date` date NULL COMMENT \"\",\n  `wp_rec_end_date` date NULL COMMENT \"\",\n  `wp_creation_date_sk` int(11) NULL COMMENT \"\",\n  `wp_access_date_sk` int(11) NULL COMMENT \"\",\n  `wp_autogen_flag` char(1) NULL COMMENT \"\",\n  `wp_customer_sk` int(11) NULL COMMENT \"\",\n  `wp_url` varchar(100) NULL COMMENT \"\",\n  `wp_type` char(50) NULL COMMENT \"\",\n  `wp_char_count` int(11) NULL COMMENT \"\",\n  `wp_link_count` int(11) NULL COMMENT \"\",\n  `wp_image_count` int(11) NULL COMMENT \"\",\n  `wp_max_ad_count` int(11) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`wp_web_page_sk`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`wp_web_page_sk`) BUCKETS 5 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\"\n);",
    "tpcds.store_sales":"CREATE TABLE `store_sales` (\n  `ss_item_sk` int(11) NOT NULL COMMENT \"\",\n  `ss_ticket_number` int(11) NOT NULL COMMENT \"\",\n  `ss_sold_date_sk` int(11) NULL COMMENT \"\",\n  `ss_sold_time_sk` int(11) NULL COMMENT \"\",\n  `ss_customer_sk` int(11) NULL COMMENT \"\",\n  `ss_cdemo_sk` int(11) NULL COMMENT \"\",\n  `ss_hdemo_sk` int(11) NULL COMMENT \"\",\n  `ss_addr_sk` int(11) NULL COMMENT \"\",\n  `ss_store_sk` int(11) NULL COMMENT \"\",\n  `ss_promo_sk` int(11) NULL COMMENT \"\",\n  `ss_quantity` int(11) NULL COMMENT \"\",\n  `ss_wholesale_cost` decimal(7, 2) NULL COMMENT \"\",\n  `ss_list_price` decimal(7, 2) NULL COMMENT \"\",\n  `ss_sales_price` decimal(7, 2) NULL COMMENT \"\",\n  `ss_ext_discount_amt` decimal(7, 2) NULL COMMENT \"\",\n  `ss_ext_sales_price` decimal(7, 2) NULL COMMENT \"\",\n  `ss_ext_wholesale_cost` decimal(7, 2) NULL COMMENT \"\",\n  `ss_ext_list_price` decimal(7, 2) NULL COMMENT \"\",\n  `ss_ext_tax` decimal(7, 2) NULL COMMENT \"\",\n  `ss_coupon_amt` decimal(7, 2) NULL COMMENT \"\",\n  `ss_net_paid` decimal(7, 2) NULL COMMENT \"\",\n  `ss_net_paid_inc_tax` decimal(7, 2) NULL COMMENT \"\",\n  `ss_net_profit` decimal(7, 2) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`ss_item_sk`, `ss_ticket_number`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`ss_item_sk`, `ss_ticket_number`) BUCKETS 192 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\"\n);",
    "tpcds.web_returns":"CREATE TABLE `web_returns` (\n  `wr_item_sk` int(11) NOT NULL COMMENT \"\",\n  `wr_order_number` int(11) NOT NULL COMMENT \"\",\n  `wr_returned_date_sk` int(11) NULL COMMENT \"\",\n  `wr_returned_time_sk` int(11) NULL COMMENT \"\",\n  `wr_refunded_customer_sk` int(11) NULL COMMENT \"\",\n  `wr_refunded_cdemo_sk` int(11) NULL COMMENT \"\",\n  `wr_refunded_hdemo_sk` int(11) NULL COMMENT \"\",\n  `wr_refunded_addr_sk` int(11) NULL COMMENT \"\",\n  `wr_returning_customer_sk` int(11) NULL COMMENT \"\",\n  `wr_returning_cdemo_sk` int(11) NULL COMMENT \"\",\n  `wr_returning_hdemo_sk` int(11) NULL COMMENT \"\",\n  `wr_returning_addr_sk` int(11) NULL COMMENT \"\",\n  `wr_web_page_sk` int(11) NULL COMMENT \"\",\n  `wr_reason_sk` int(11) NULL COMMENT \"\",\n  `wr_return_quantity` int(11) NULL COMMENT \"\",\n  `wr_return_amt` decimal(7, 2) NULL COMMENT \"\",\n  `wr_return_tax` decimal(7, 2) NULL COMMENT \"\",\n  `wr_return_amt_inc_tax` decimal(7, 2) NULL COMMENT \"\",\n  `wr_fee` decimal(7, 2) NULL COMMENT \"\",\n  `wr_return_ship_cost` decimal(7, 2) NULL COMMENT \"\",\n  `wr_refunded_cash` decimal(7, 2) NULL COMMENT \"\",\n  `wr_reversed_charge` decimal(7, 2) NULL COMMENT \"\",\n  `wr_account_credit` decimal(7, 2) NULL COMMENT \"\",\n  `wr_net_loss` decimal(7, 2) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`wr_item_sk`, `wr_order_number`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`wr_item_sk`, `wr_order_number`) BUCKETS 5 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\"\n);",
    "tpcds.date_dim":"CREATE TABLE `date_dim` (\n  `d_date_sk` int(11) NOT NULL COMMENT \"\",\n  `d_date_id` char(16) NOT NULL COMMENT \"\",\n  `d_date` date NULL COMMENT \"\",\n  `d_month_seq` int(11) NULL COMMENT \"\",\n  `d_week_seq` int(11) NULL COMMENT \"\",\n  `d_quarter_seq` int(11) NULL COMMENT \"\",\n  `d_year` int(11) NULL COMMENT \"\",\n  `d_dow` int(11) NULL COMMENT \"\",\n  `d_moy` int(11) NULL COMMENT \"\",\n  `d_dom` int(11) NULL COMMENT \"\",\n  `d_qoy` int(11) NULL COMMENT \"\",\n  `d_fy_year` int(11) NULL COMMENT \"\",\n  `d_fy_quarter_seq` int(11) NULL COMMENT \"\",\n  `d_fy_week_seq` int(11) NULL COMMENT \"\",\n  `d_day_name` char(9) NULL COMMENT \"\",\n  `d_quarter_name` char(6) NULL COMMENT \"\",\n  `d_holiday` char(1) NULL COMMENT \"\",\n  `d_weekend` char(1) NULL COMMENT \"\",\n  `d_following_holiday` char(1) NULL COMMENT \"\",\n  `d_first_dom` int(11) NULL COMMENT \"\",\n  `d_last_dom` int(11) NULL COMMENT \"\",\n  `d_same_day_ly` int(11) NULL COMMENT \"\",\n  `d_same_day_lq` int(11) NULL COMMENT \"\",\n  `d_current_day` char(1) NULL COMMENT \"\",\n  `d_current_week` char(1) NULL COMMENT \"\",\n  `d_current_month` char(1) NULL COMMENT \"\",\n  `d_current_quarter` char(1) NULL COMMENT \"\",\n  `d_current_year` char(1) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`d_date_sk`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`d_date_sk`) BUCKETS 5 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\"\n);",
    "tpcds.store_returns":"CREATE TABLE `store_returns` (\n  `sr_item_sk` int(11) NOT NULL COMMENT \"\",\n  `sr_ticket_number` int(11) NOT NULL COMMENT \"\",\n  `sr_returned_date_sk` int(11) NULL COMMENT \"\",\n  `sr_return_time_sk` int(11) NULL COMMENT \"\",\n  `sr_customer_sk` int(11) NULL COMMENT \"\",\n  `sr_cdemo_sk` int(11) NULL COMMENT \"\",\n  `sr_hdemo_sk` int(11) NULL COMMENT \"\",\n  `sr_addr_sk` int(11) NULL COMMENT \"\",\n  `sr_store_sk` int(11) NULL COMMENT \"\",\n  `sr_reason_sk` int(11) NULL COMMENT \"\",\n  `sr_return_quantity` int(11) NULL COMMENT \"\",\n  `sr_return_amt` decimal(7, 2) NULL COMMENT \"\",\n  `sr_return_tax` decimal(7, 2) NULL COMMENT \"\",\n  `sr_return_amt_inc_tax` decimal(7, 2) NULL COMMENT \"\",\n  `sr_fee` decimal(7, 2) NULL COMMENT \"\",\n  `sr_return_ship_cost` decimal(7, 2) NULL COMMENT \"\",\n  `sr_refunded_cash` decimal(7, 2) NULL COMMENT \"\",\n  `sr_reversed_charge` decimal(7, 2) NULL COMMENT \"\",\n  `sr_store_credit` decimal(7, 2) NULL COMMENT \"\",\n  `sr_net_loss` decimal(7, 2) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`sr_item_sk`, `sr_ticket_number`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`sr_item_sk`, `sr_ticket_number`) BUCKETS 5 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\"\n);",
    "tpcds.store":"CREATE TABLE `store` (\n  `s_store_sk` int(11) NOT NULL COMMENT \"\",\n  `s_store_id` char(16) NOT NULL COMMENT \"\",\n  `s_rec_start_date` date NULL COMMENT \"\",\n  `s_rec_end_date` date NULL COMMENT \"\",\n  `s_closed_date_sk` int(11) NULL COMMENT \"\",\n  `s_store_name` varchar(50) NULL COMMENT \"\",\n  `s_number_employees` int(11) NULL COMMENT \"\",\n  `s_floor_space` int(11) NULL COMMENT \"\",\n  `s_hours` char(20) NULL COMMENT \"\",\n  `s_manager` varchar(40) NULL COMMENT \"\",\n  `s_market_id` int(11) NULL COMMENT \"\",\n  `s_geography_class` varchar(100) NULL COMMENT \"\",\n  `s_market_desc` varchar(100) NULL COMMENT \"\",\n  `s_market_manager` varchar(40) NULL COMMENT \"\",\n  `s_division_id` int(11) NULL COMMENT \"\",\n  `s_division_name` varchar(50) NULL COMMENT \"\",\n  `s_company_id` int(11) NULL COMMENT \"\",\n  `s_company_name` varchar(50) NULL COMMENT \"\",\n  `s_street_number` varchar(10) NULL COMMENT \"\",\n  `s_street_name` varchar(60) NULL COMMENT \"\",\n  `s_street_type` char(15) NULL COMMENT \"\",\n  `s_suite_number` char(10) NULL COMMENT \"\",\n  `s_city` varchar(60) NULL COMMENT \"\",\n  `s_county` varchar(30) NULL COMMENT \"\",\n  `s_state` char(2) NULL COMMENT \"\",\n  `s_zip` char(10) NULL COMMENT \"\",\n  `s_country` varchar(20) NULL COMMENT \"\",\n  `s_gmt_offset` decimal(5, 2) NULL COMMENT \"\",\n  `s_tax_precentage` decimal(5, 2) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`s_store_sk`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`s_store_sk`) BUCKETS 5 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\"\n);",
    "tpcds.catalog_returns":"CREATE TABLE `catalog_returns` (\n  `cr_item_sk` int(11) NOT NULL COMMENT \"\",\n  `cr_order_number` int(11) NOT NULL COMMENT \"\",\n  `cr_returned_date_sk` int(11) NULL COMMENT \"\",\n  `cr_returned_time_sk` int(11) NULL COMMENT \"\",\n  `cr_refunded_customer_sk` int(11) NULL COMMENT \"\",\n  `cr_refunded_cdemo_sk` int(11) NULL COMMENT \"\",\n  `cr_refunded_hdemo_sk` int(11) NULL COMMENT \"\",\n  `cr_refunded_addr_sk` int(11) NULL COMMENT \"\",\n  `cr_returning_customer_sk` int(11) NULL COMMENT \"\",\n  `cr_returning_cdemo_sk` int(11) NULL COMMENT \"\",\n  `cr_returning_hdemo_sk` int(11) NULL COMMENT \"\",\n  `cr_returning_addr_sk` int(11) NULL COMMENT \"\",\n  `cr_call_center_sk` int(11) NULL COMMENT \"\",\n  `cr_catalog_page_sk` int(11) NULL COMMENT \"\",\n  `cr_ship_mode_sk` int(11) NULL COMMENT \"\",\n  `cr_warehouse_sk` int(11) NULL COMMENT \"\",\n  `cr_reason_sk` int(11) NULL COMMENT \"\",\n  `cr_return_quantity` int(11) NULL COMMENT \"\",\n  `cr_return_amount` decimal(7, 2) NULL COMMENT \"\",\n  `cr_return_tax` decimal(7, 2) NULL COMMENT \"\",\n  `cr_return_amt_inc_tax` decimal(7, 2) NULL COMMENT \"\",\n  `cr_fee` decimal(7, 2) NULL COMMENT \"\",\n  `cr_return_ship_cost` decimal(7, 2) NULL COMMENT \"\",\n  `cr_refunded_cash` decimal(7, 2) NULL COMMENT \"\",\n  `cr_reversed_charge` decimal(7, 2) NULL COMMENT \"\",\n  `cr_store_credit` decimal(7, 2) NULL COMMENT \"\",\n  `cr_net_loss` decimal(7, 2) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`cr_item_sk`, `cr_order_number`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`cr_item_sk`, `cr_order_number`) BUCKETS 5 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\"\n);",
    "tpcds.web_sales":"CREATE TABLE `web_sales` (\n  `ws_item_sk` int(11) NOT NULL COMMENT \"\",\n  `ws_order_number` int(11) NOT NULL COMMENT \"\",\n  `ws_sold_date_sk` int(11) NULL COMMENT \"\",\n  `ws_sold_time_sk` int(11) NULL COMMENT \"\",\n  `ws_ship_date_sk` int(11) NULL COMMENT \"\",\n  `ws_bill_customer_sk` int(11) NULL COMMENT \"\",\n  `ws_bill_cdemo_sk` int(11) NULL COMMENT \"\",\n  `ws_bill_hdemo_sk` int(11) NULL COMMENT \"\",\n  `ws_bill_addr_sk` int(11) NULL COMMENT \"\",\n  `ws_ship_customer_sk` int(11) NULL COMMENT \"\",\n  `ws_ship_cdemo_sk` int(11) NULL COMMENT \"\",\n  `ws_ship_hdemo_sk` int(11) NULL COMMENT \"\",\n  `ws_ship_addr_sk` int(11) NULL COMMENT \"\",\n  `ws_web_page_sk` int(11) NULL COMMENT \"\",\n  `ws_web_site_sk` int(11) NULL COMMENT \"\",\n  `ws_ship_mode_sk` int(11) NULL COMMENT \"\",\n  `ws_warehouse_sk` int(11) NULL COMMENT \"\",\n  `ws_promo_sk` int(11) NULL COMMENT \"\",\n  `ws_quantity` int(11) NULL COMMENT \"\",\n  `ws_wholesale_cost` decimal(7, 2) NULL COMMENT \"\",\n  `ws_list_price` decimal(7, 2) NULL COMMENT \"\",\n  `ws_sales_price` decimal(7, 2) NULL COMMENT \"\",\n  `ws_ext_discount_amt` decimal(7, 2) NULL COMMENT \"\",\n  `ws_ext_sales_price` decimal(7, 2) NULL COMMENT \"\",\n  `ws_ext_wholesale_cost` decimal(7, 2) NULL COMMENT \"\",\n  `ws_ext_list_price` decimal(7, 2) NULL COMMENT \"\",\n  `ws_ext_tax` decimal(7, 2) NULL COMMENT \"\",\n  `ws_coupon_amt` decimal(7, 2) NULL COMMENT \"\",\n  `ws_ext_ship_cost` decimal(7, 2) NULL COMMENT \"\",\n  `ws_net_paid` decimal(7, 2) NULL COMMENT \"\",\n  `ws_net_paid_inc_tax` decimal(7, 2) NULL COMMENT \"\",\n  `ws_net_paid_inc_ship` decimal(7, 2) NULL COMMENT \"\",\n  `ws_net_paid_inc_ship_tax` decimal(7, 2) NULL COMMENT \"\",\n  `ws_net_profit` decimal(7, 2) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`ws_item_sk`, `ws_order_number`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`ws_item_sk`, `ws_order_number`) BUCKETS 192 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\"\n);"
  },
  "table_row_count":{
    "tpcds.catalog_sales":{
      "catalog_sales":1439980416
    },
    "tpcds.store_sales":{
      "store_sales":2879987999
    },
    "tpcds.web_page":{
      "web_page":3000
    },
    "tpcds.web_returns":{
      "web_returns":71997522
    },
    "tpcds.web_sales":{
      "web_sales":720000376
    },
    "tpcds.date_dim":{
      "date_dim":73049
    },
    "tpcds.catalog_returns":{
      "catalog_returns":143996756
    },
    "tpcds.store":{
      "store":1002
    }
  },
  "session_variables":"{\"runtime_join_filter_push_down_limit\":1024000,\"codegen_level\":0,\"character_set_connection\":\"utf8\",\"enable_insert_strict\":false,\"div_precision_increment\":4,\"tx_isolation\":\"REPEATABLE-READ\",\"wait_timeout\":28800,\"auto_increment_increment\":1,\"foreign_key_checks\":true,\"character_set_client\":\"utf8\",\"autocommit\":true,\"character_set_results\":\"utf8\",\"parallel_fragment_exec_instance_num\":16,\"max_scan_key_num\":-1,\"enable_global_runtime_filter\":false,\"forward_to_master\":false,\"net_read_timeout\":60,\"streaming_preaggregation_mode\":\"auto\",\"storage_engine\":\"olap\",\"cbo_enable_dp_join_reorder\":true,\"tx_visible_wait_timeout\":10,\"cbo_max_reorder_node_use_exhaustive\":4,\"new_planner_optimize_timeout\":3000,\"force_schedule_local\":false,\"query_threads\":1,\"enable_query_dump\":false,\"prefer_join_method\":\"broadcast\",\"cbo_enable_greedy_join_reorder\":true,\"load_mem_limit\":40000000000,\"sql_select_limit\":9223372036854775807,\"profiling\":false,\"sql_safe_updates\":0,\"enable_pipeline_engine\":false,\"query_cache_type\":0,\"use_v2_rollup\":false,\"disable_colocate_join\":false,\"max_pushdown_conditions_per_column\":-1,\"enable_vectorized_engine\":true,\"net_write_timeout\":60,\"collation_database\":\"utf8_general_ci\",\"hash_join_push_down_right_table\":true,\"new_planner_agg_stage\":0,\"collation_connection\":\"utf8_general_ci\",\"resource_group\":\"normal\",\"enable_new_planner_push_down_join_to_agg\":false,\"broadcast_row_limit\":15000000,\"exec_mem_limit\":128849018880,\"cbo_max_reorder_node_use_dp\":10,\"disable_join_reorder\":false,\"enable_profile\":true,\"enable_cbo_meta\":true,\"enable_groupby_use_output_alias\":false,\"enable_vectorized_insert\":true,\"net_buffer_length\":16384,\"transmission_compression_type\":\"LZ4\",\"interactive_timeout\":3600,\"enable_spilling\":false,\"batch_size\":1024,\"max_allowed_packet\":1048576,\"query_timeout\":3000,\"test_materialized_view\":false,\"collation_server\":\"utf8_general_ci\",\"time_zone\":\"Asia/Shanghai\",\"max_execution_time\":3000000,\"character_set_server\":\"utf8\",\"rewrite_count_distinct_to_bitmap_hll\":true,\"parallel_exchange_instance_num\":-1,\"sql_mode\":34,\"SQL_AUTO_IS_NULL\":false,\"event_scheduler\":\"OFF\",\"disable_streaming_preaggregations\":false}",
  "column_statistics":{
    "tpcds.catalog_sales":{
      "cs_sold_date_sk":"[-Infinity, Infinity, 0.0, 1.0, 1.0]",
      "cs_ext_sales_price":"[-Infinity, Infinity, 0.0, 1.0, 1.0]",
      "cs_net_profit":"[-Infinity, Infinity, 0.0, 1.0, 1.0]",
      "cs_call_center_sk":"[-Infinity, Infinity, 0.0, 1.0, 1.0]"
    },
    "tpcds.store_sales":{
      "ss_ext_sales_price":"[-Infinity, Infinity, 0.0, 1.0, 1.0]",
      "ss_net_profit":"[-Infinity, Infinity, 0.0, 1.0, 1.0]",
      "ss_sold_date_sk":"[-Infinity, Infinity, 0.0, 1.0, 1.0]",
      "ss_store_sk":"[-Infinity, Infinity, 0.0, 1.0, 1.0]"
    },
    "tpcds.web_page":{
      "wp_web_page_sk":"[-Infinity, Infinity, 0.0, 1.0, 1.0]"
    },
    "tpcds.web_returns":{
      "wr_return_amt":"[-Infinity, Infinity, 0.0, 1.0, 1.0]",
      "wr_net_loss":"[-Infinity, Infinity, 0.0, 1.0, 1.0]",
      "wr_web_page_sk":"[-Infinity, Infinity, 0.0, 1.0, 1.0]",
      "wr_returned_date_sk":"[-Infinity, Infinity, 0.0, 1.0, 1.0]"
    },
    "tpcds.store_returns":{
      "sr_returned_date_sk":"[-Infinity, Infinity, 0.0, 1.0, 1.0]",
      "sr_return_amt":"[-Infinity, Infinity, 0.0, 1.0, 1.0]",
      "sr_store_sk":"[-Infinity, Infinity, 0.0, 1.0, 1.0]",
      "sr_net_loss":"[-Infinity, Infinity, 0.0, 1.0, 1.0]"
    },
    "tpcds.web_sales":{
      "ws_ext_sales_price":"[-Infinity, Infinity, 0.0, 1.0, 1.0]",
      "ws_sold_date_sk":"[-Infinity, Infinity, 0.0, 1.0, 1.0]",
      "ws_net_profit":"[-Infinity, Infinity, 0.0, 1.0, 1.0]",
      "ws_web_page_sk":"[-Infinity, Infinity, 0.0, 1.0, 1.0]"
    },
    "tpcds.date_dim":{
      "d_date":"[-Infinity, Infinity, 0.0, 1.0, 1.0]",
      "d_date_sk":"[-Infinity, Infinity, 0.0, 1.0, 1.0]"
    },
    "tpcds.catalog_returns":{
      "cr_net_loss":"[-Infinity, Infinity, 0.0, 1.0, 1.0]",
      "cr_return_amount":"[-Infinity, Infinity, 0.0, 1.0, 1.0]",
      "cr_call_center_sk":"[-Infinity, Infinity, 0.0, 1.0, 1.0]",
      "cr_returned_date_sk":"[-Infinity, Infinity, 0.0, 1.0, 1.0]"
    },
    "tpcds.store":{
      "s_store_sk":"[-Infinity, Infinity, 0.0, 1.0, 1.0]"
    }
  },
  "be_number":5,
  "exception":[

  ]
}
